Ì € i 2
mm.item.audit.trail (audit.trail.item)
[audit.item, audit.date,audit.seq]
*MTED[mt]A[mtMD,mtAS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L mtMD
audit.seq 4 PINT R mtAS
audit.crnt.pkging 4 INT R *MTED[mt]A[mtMD,mtAS]|2
audit.field 6 CHOICE L *MTED[mt]A[mtMD,mtAS]|3
audit.from 40 FREE L *MTED[mt]A[mtMD,mtAS]|4
audit.pkging.str 40 FREE L VAL=@packaging[@item.urn,@audit.crnt.pkging]
audit.source 20 CHOICE L *MTED[mt]A[mtMD,mtAS]|6
audit.time 5 HHMM L *MTED[mt]A[mtMD,mtAS]|1
audit.to 40 FREE L *MTED[mt]A[mtMD,mtAS]|5
audit.user 10 FREE L MIS.USER *MTED[mt]A[mtMD,mtAS]|0
Ì € i 2
mm.item.audit.trail.vendors (audit.trail.vendors)
[audit.item,audit.date,audit.seq, audit.vend.no]
*MTED[mt]A[mtMD,mtAS]V[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vend.no 11 FREE L MIS.VEN gr
audit.vend.field 6 CHOICE L *MTED[mt]A[mtMD,mtAS]V[gr]|3
audit.vend.from 40 FREE L *MTED[mt]A[mtMD,mtAS]V[gr]|4
audit.vend.pkg.no 4 INT R *MTED[mt]A[mtMD,mtAS]V[gr]|2
audit.vend.source 20 CHOICE L *MTED[mt]A[mtMD,mtAS]V[gr]|6
audit.vend.time 5 HHMM L *MTED[mt]A[mtMD,mtAS]V[gr]|1
audit.vend.to 40 FREE L *MTED[mt]A[mtMD,mtAS]V[gr]|5
audit.vend.user 10 FREE L MIS.USER *MTED[mt]A[mtMD,mtAS]V[gr]|0
Ì € i 2
mm.item.audit.trail.vpi (audit.trail.vpi)
[audit.item,audit.date,audit.seq,audit.vend.no, audit.vend.pkg.no]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vend.pkg.no 4 INT R *MTED[mt]A[mtMD,mtAS]V[gr]|2
Ì i 2
mm.item (main)
[item.urn]
*MT[mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.urn 73 URN L mt
active 1 YN L *MT[mt]|0
category 8 FREE L MM.CATEGORY *MT[mt]|3
crnt.pkging 4 INT R *MT[mt]|20
dept.default.inventory 10 FREE L MM.INVENT *MT[mt]DP|1
dept.default.max 12 INT R *MT[mt]DP|3
dept.default.min 12 INT R *MT[mt]DP|2
dept.default.purchase 1 YN L *MT[mt]DP|0
desc.line2 30 FREE L *MT[mt]|5
description 30 FREE L *MT[mt]|4
disc.comment 30 FREE L *MT[mt]|9
exp.obj.code 7 FREE L MIS.GL.EOC *MT[mt]|6
form 8 FREE L MM.FORM.DICT *MT[mt]|12
from.pha 1 YN L *MT[mt]|17
id 73 URN L MM.ITEM VAL=(@MM.ITEM.number_" - "_@MM.ITEM.zcus.uk.descriptio
VAL=n'=" - ")
implantable 1 YN L *MT[mt]|21
int.id 73 URN L VAL=@number
largest.common.unit 4 INT R *MT[mt]|13
largest.common.unit.disp 4 FREE L VAL=IF{@MM.ITEM.largest.common.unit=0 @MM.ITEM.smalles
VAL=t.unit;@MM.ITEM.pkg.size[@MM.ITEM.crnt.pkging,@MM.
VAL=ITEM.largest.common.unit]}
largest.common.unit.us 7 PINT R *MT[mt]|14
last.update 10 FREE L *MT[mt]UPD
mark.up.per 8 PDEC4 R *MT[mt]|16
name 30 FREE L *MT[mt]|2
number 10 FREE L *MT[mt]|1
package.string 40 FREE L VAL=@packaging[@item.urn,@crnt.pkging]
package.string.disp 40 FREE L VAL=@MM.ITEM.packaging[@MM.ITEM.item.urn,@MM.ITEM.crnt
VAL=.pkging]
pha.db 12 FREE L MIS.APPL *MT[mt]|19
pha.drug 10 FREE L PHA.DRUG *MT[mt]|18
pha.generic.name 30 FREE L *MT[mt]C|0
pha.ndc.din.number 12 FREE L *MT[mt]C|1
procedure.code 10 FREE L *MT[mt]|8
pvend.cat.no 15 FREE L *MT[mt]PV|1
pvend.comment 60 FREE L *MT[mt]PV|13
pvend.cont.exp.date 8 DATE L *MT[mt]PV|12
pvend.cont.group 60 FREE L *MT[mt]PV|11
pvend.contract.no 10 FREE L *MT[mt]PV|10
pvend.conv.pkg.size 10 FREE L *MT[mt]PV|6
pvend.cost.up 10 DEC4 R *MT[mt]PV|5
pvend.cost.us 10 DEC4 R *MT[mt]PV|14
pvend.manuf 10 FREE L MIS.MFR *MT[mt]PV|3
pvend.manuf.cat.no 15 FREE L *MT[mt]PV|4
pvend.no 11 FREE L MIS.VEN *MT[mt]PV|0
pvend.unit.of.pur 10 FREE L *MT[mt]PV|7
pvend.unit.of.pur.num 4 FREE L VAL=(@pvend.unit.of.pur$(L(@pvend.unit.of.pur," "))?0N
VAL=!1)
pvend.unit.of.pur.unit 5 FREE L VAL=(@pvend.unit.of.pur%(L(@pvend.unit.of.pur," "))!@p
VAL=vend.unit.of.pur)
pvend.up.us 5 PINT R *MT[mt]PV|9
pvend.up.with.us 15 FREE L *MT[mt]PV|8
smallest.unit 4 FREE L *MT[mt]|11
sort.id 73 FREE L
stock.id.desc 79 FREE L VAL=@MM.ITEM.number_IF{@MM.ITEM.disc.comment " **DISCO
VAL=NT'D**"}_" "_@MM.ITEM.zcus.uk.description_IF{@MM.I
VAL=TEM.name " ("_@MM.ITEM.name_")"}
tax.code 3 FREE L MIS.TAX.CODE *MT[mt]|15
taxable 1 YN L *MT[mt]|10
zcus.uk.desc.line2 65 FREE L *MT[mt]ZCUSUKD|1
zcus.uk.description 65 FREE L *MT[mt]ZCUSUKD|0
Ì € i 2
mm.item.dept.info (dept.info)
[item.urn, department]
*MT[mt]DP[gd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
department 15 FREE L MIS.GL.DEPT gd
inventory 10 FREE L MM.INVENT *MT[mt]DP[gd]|0
max 12 INT R *MT[mt]DP[gd]|2
min 12 INT R *MT[mt]DP[gd]|1
purchase 1 YN L *MT[mt]DP[gd]|3
view 1 FREE L VAL=IF{+@dept.info[@t.item.urn,""] %MM.ITEM.view.combi
VAL=ned.req.info(VW),1^VW,"Y";"N"}
Ì € i 2
mm.item.packaging.tree (packaging.tree)
[item.urn, pkg.no]
*MT[mt]T[mtT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.no 3 URN L mtT
activated.by.user 10 FREE L *MT[mt]T[mtT]|2
date.string.activated 8 DATE L *MT[mt]T[mtT]|1
date.string.retired 8 DATE L *MT[mt]T[mtT]|3
disc.reason 30 FREE L *MT[mt]T[mtT]|5
packaging 40 FREE L *MT[mt]T[mtT]|0
retired.by.user 10 FREE L *MT[mt]T[mtT]|4
Ì € i 2
mm.item.unit (unit)
[item.urn,pkg.no, sizeno]
*MT[mt]T[mtT]U[mtU]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sizeno 3 URN L mtU
conv.factor 5 PINT R *MT[mt]T[mtT]U[mtU]|2
pkg.size 4 FREE L *MT[mt]T[mtT]U[mtU]|0
units.per 5 PINT R *MT[mt]T[mtT]U[mtU]|1
Ì € i 2
mm.item.vendor.order (vendor.order)
[item.urn, vendor.order.no]
*MT[mt]O[mtV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor.order.no 2 PINT R mtV
dis.vend.contract 1 FREE L VAL=IF{@vend.contract.no[@vendor.num] "Y";"N"}
dis.vend.cost 11 SMONEY R VAL=@vend.cost.up[@vendor.num,@crnt.pkging+0]:2D
dis.vend.name 35 FREE L VAL=@MIS.VEN.name[@vendor.num]
dis.vend.up 10 FREE L VAL=@vend.unit.of.pur[@vendor.num,@crnt.pkging+0]
vendor.num 11 FREE L MIS.VEN *MT[mt]O[mtV]|1
Ì € i 2
mm.item.vendors (vendors)
[item.urn, vendor.no]
*MT[mt]V[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor.no 11 FREE L MIS.VEN gr
vend.active 1 YN L *MT[mt]V[gr]|0
vend.cat.no 15 FREE L *MT[mt]V[gr]|1
vend.comment 75 FREE L *MT[mt]V[gr]|13
vend.cont.exp.date 8 DATE L *MT[mt]V[gr]|12
vend.cont.group 60 FREE L *MT[mt]V[gr]|11
vend.contract.no 15 FREE L *MT[mt]V[gr]|10
vend.manuf 10 FREE L MIS.MFR *MT[mt]V[gr]|3
vend.manuf.cat.no 15 FREE L *MT[mt]V[gr]|4
Ì € i 2
mm.item.vendor.contracts (vendor.contracts)
[item.urn,vendor.no, cntr.eff.date]
*MT[mt]V[gr]C[mtCD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cntr.eff.date 8 DATE L mtCD
cntr.cost.up 10 PDEC4 R *MT[mt]V[gr]C[mtCD]|1
cntr.number 15 FREE L *MT[mt]V[gr]C[mtCD]|0
Ì € i 2
mm.item.vendors.purch.info (vendor.purch.info)
[item.urn,vendor.no, vend.pkg.no]
*MT[mt]V[gr]A[mtT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vend.pkg.no 4 URN L mtT
vend.conv.pkg.size 10 FREE L *MT[mt]V[gr]A[mtT]|2
vend.cost.up 10 DEC4 R *MT[mt]V[gr]A[mtT]|1
vend.cost.us 10 DEC4 R *MT[mt]V[gr]A[mtT]|5
vend.unit.of.pur 10 FREE L *MT[mt]V[gr]A[mtT]|0
vend.unit.sizeno 4 PINT R *MT[mt]V[gr]A[mtT]|6
vend.up.upn 20 FREE L *MT[mt]V[gr]A[mtT]|7
vend.up.us 5 PINT R *MT[mt]V[gr]A[mtT]|4
vend.up.with.us 15 FREE L *MT[mt]V[gr]A[mtT]|3
Ì € i 2
mm.item.upn (universal.product.number)
[item.urn,vendor.no,vend.pkg.no, upn]
*MT[mt]V[gr]A[mtT]UPN[upn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
upn 20 FREE L upn
upn.pkg 4 FREE L *MT[mt]V[gr]A[mtT]UPN[upn]|1
Ì i 2
mm.item.pha.queue (pha.queue)
[pha.date,pha.q]
*MTPQ[mtpd,mtpq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pha.date 8 DATE L mtpd
pha.q 3 PINT R mtpq
pha.cat.no 15 FREE L *MTPQ[mtpd,mtpq]|4
pha.conv.pkg.size 10 FREE L *MTPQ[mtpd,mtpq]|9
pha.cost.up 10 DEC4 R *MTPQ[mtpd,mtpq]|6
pha.database 12 FREE L MIS.APPL *MTPQ[mtpd,mtpq]|0
pha.flag 10 FREE L *MTPQ[mtpd,mtpq]|10
pha.inventory 10 FREE L MM.INVENT *MTPQ[mtpd,mtpq]|8
pha.item 73 URN L MM.ITEM *MTPQ[mtpd,mtpq]|2
pha.type 1 CHOICE L *MTPQ[mtpd,mtpq]|1
pha.up 10 FREE L *MTPQ[mtpd,mtpq]|5
pha.updated 1 YN L *MTPQ[mtpd,mtpq]|7
pha.vendor 11 FREE L MIS.VEN *MTPQ[mtpd,mtpq]|3
Ì i 2
mm.item.pkg.copy (pkg.copy)
*MTPC
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.copy.created 10 FREE L *MTPC|0
pkg.copy.last.edit 10 FREE L *MTPC|1
Ì i 2
mm.item.pkg.copy.list (pkg.copy.list)
[pkg.copy.string]
*MTPC[mtP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.copy.string 40 FREE L mtP
Ì i 2
mm.item.pkg.templates (pkg.templates)
[pkg.string]
*MTP[mtP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.string 40 mtP
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mm.item.category.index [category,item.urn]
categ.x ?MTC[ma,mt]
mm.item.manuf.catlg.index [pvend.manuf.cat.no,item.urn]
catlg.x ?MTMC[gmC,mt]
mm.item.component.indexc [component,item.urn]
component.x ?MTCX[mtC,mt]
mm.item.dept.item.index [department,item.urn]
dept.item.x ?MTDIX[gd,mt]
mm.item.description.number.x [description,number] = item.urn
desc.number.x ?MTDN[mtD,mtR]
mm.item.description.index [description,item.urn]
desc.x ?MTD[mtD,mt]
mm.item.drug.index [pha.drug,item.urn]
drug.x ?MTG[tf,mt]
mm.item.forms.index [form,item.urn]
forms.x ?MTFX[mv,mt]
mm.item.generic.name.index [pha.generic.name,item.urn]
generic.name.x ?MTGN[tdgN,mt]
mm.item.id.x [sort.id,item.urn]
id.x ?MTI[mtI,mt]
mm.item.intersect.list [item.urn]
intersect.list /MTLX[mt]
mm.item.key.pointer.value.list [key,key.urn,key.value]
key.pointer.value.list /MTK[mtK,mt,mtKV]
mm.item.key.value.list [key,key.value]
key.value.list /MTVK[mtK,mtKV]
mm.item.manufacturer.index [vend.manuf,item.urn]
manuf.x ?MTM[gm,mt]
mm.item.ndc.din.index [pha.ndc.din.number,item.urn]
ndc.din.x ?MTND[tfND,mt]
mm.item.number.index [number,item.urn]
number.x ?MTR[mtR,mt]
mm.item.proc.code.x [procedure.code,item.urn]
proc.code.x ?MTBC[bd,mt]
mm.item.tax.code.index [tax.code,item.urn]
tax.code.x ?MTTX[gea,mt]
mm.item.trade.name.index [name,item.urn]
trade.name.x ?MTTN[mtN,mt]
mm.item.upn.index [upn,item.urn]
upn.x ?MTUPN[upn,mt]
mm.item.vendor.catlg.index [vend.cat.no,item.urn]
ven.catlg.x ?MTVC[gvC,mt]
mm.item.vendor.index [vendor.no,item.urn,vendor.order.no]
vendor.id.x ?MTV[gr,mt,mtV]
drug/database/item urn index [pha.drug,pha.db,item.urn]
zcus.uk.drug.db.x ?MTZCUS.GDB[tf,iaD,mt]
|
|
| | | | | | | | | | | | | | |